CREATE TABLE [dbo].[CostTier]
(
[CostTierKey] [uniqueidentifier] NOT NULL,
[ProductKey] [uniqueidentifier] NOT NULL,
[QuantityOnHand] [decimal] (18, 8) NOT NULL,
[QuantityReceived] [decimal] (18, 8) NOT NULL,
[UnitCost] [decimal] (18, 4) NOT NULL,
[DateReceived] [datetime] NOT NULL,
[WarehouseKey] [uniqueidentifier] NOT NULL,
[TotalCost] [decimal] (18, 4) NOT NULL,
[ProductInventoryKey] [uniqueidentifier] NULL,
[UomKey] [uniqueidentifier] NOT NULL,
[OriginalReceiptKey] [uniqueidentifier] NULL,
[CostMethodCode] [int] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CostTier] ADD CONSTRAINT [PK_CostTier] PRIMARY KEY CLUSTERED ([CostTierKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CostTier_CostMethodCode] ON [dbo].[CostTier] ([CostMethodCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CostTier_ProductKey_WarehouseKey] ON [dbo].[CostTier] ([ProductKey], [WarehouseKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CostTier] ADD CONSTRAINT [FK_CostTier_CostMethodRef] FOREIGN KEY ([CostMethodCode]) REFERENCES [dbo].[CostMethodRef] ([CostMethodCode])
GO